/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

/* UserPreferences */
GO
EXECUTE sp_rename N'dbo.UserPreferences.facebookUserId', N'Tmp_FacebookUserId', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserPreferences.visibilityLevel', N'Tmp_VisibilityLevel_1', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserPreferences.nearbyRadiusKM', N'Tmp_NearbyRadiusKM_2', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserPreferences.twitterAlias', N'Tmp_TwitterAlias_3', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserPreferences.twitterWelcomeSent', N'Tmp_TwitterWelcomeSent_4', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserPreferences.Tmp_FacebookUserId', N'FacebookUserId', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserPreferences.Tmp_VisibilityLevel_1', N'VisibilityLevel', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserPreferences.Tmp_NearbyRadiusKM_2', N'NearbyRadiusKM', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserPreferences.Tmp_TwitterAlias_3', N'TwitterAlias', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserPreferences.Tmp_TwitterWelcomeSent_4', N'TwitterWelcomeSent', 'COLUMN' 
GO

/* UserLocation */
EXECUTE sp_rename N'dbo.UserLocation.facebookUserId', N'Tmp_FacebookUserId_5', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserLocation.lat', N'Tmp_Lat_6', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserLocation.long', N'Tmp_Long_7', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserLocation.Tmp_FacebookUserId_5', N'FacebookUserId', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserLocation.Tmp_Lat_6', N'Lat', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserLocation.Tmp_Long_7', N'Long', 'COLUMN' 
GO

/* UserRegistry */
EXECUTE sp_rename N'dbo.UserRegistry.facebookUserId', N'Tmp_FacebookUserId_8', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserRegistry.sessionKey', N'Tmp_SessionKey_9', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserRegistry.Tmp_FacebookUserId_8', N'FacebookUserId', 'COLUMN' 
GO
EXECUTE sp_rename N'dbo.UserRegistry.Tmp_SessionKey_9', N'SessionKey', 'COLUMN' 
GO
COMMIT